package thefirst.member.model;

import java.sql.SQLException;
import java.util.List;

import thefirst.support.model.HelpVO;
import thefirst.support.model.NoticeVO;
/**
 * MemberDao 
 * registerMember - 회원들의 가입에 대한 메서드
 * showMember - 회원 정보를 조회가 가능한 메서드 
 * 				여러 서비스에서 활용 가능
 * @author kosta-00-30
 *
 */
public interface MemberDao {
	
	public void registerMember(MemberVO mvo) throws SQLException;
	public MemberVO showMember(MemberVO mvo) throws SQLException;
	public int isExistId(MemberVO mvo) throws SQLException;
	/*public int upload(TeacherVO tvo) throws SQLException;*/
	public int updateName(MemberVO mvo) throws SQLException;
	public int updateGender(MemberVO mvo) throws SQLException;
	public int updateTel(MemberVO mvo) throws SQLException;
	public int updateEmail(MemberVO mvo) throws SQLException;
	public int updateHoperegion(MemberVO mvo) throws SQLException;
	public MemberVO login(MemberVO mvo)throws SQLException;
	
	public int selectTotalMemberCount() throws SQLException;//페이징빈을 처리하기 위하여 전체학생수
	
	public List<?> getMemberListBasic(int pageNo) throws SQLException;	//페이징빈에 처리하기위한 학생리스트

	public void withdrawalMember(MemberVO mvo)throws SQLException;

	public String findIdByNameEmail(MemberVO mvo) throws SQLException;
	public MemberVO findQPassByIdEmail(MemberVO mvo) throws SQLException;
	public String findPasswordByQnAPass(MemberVO mvo) throws SQLException;
	public List<?> getListForAdmin(String pageNo) throws SQLException;
	public List<?> getMyHelpList(MyHelpVO myHelpVO) throws SQLException;
}
